<?php
define('InEmpireBakData',TRUE);
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 5.1
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `jzb_order_product`;");
E_C("CREATE TABLE `jzb_order_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `product_title` char(60) NOT NULL,
  `product_attr` text NOT NULL,
  `identify_price` decimal(10,2) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  `create_time` int(11) NOT NULL,
  `update_time` int(11) NOT NULL,
  `return_status` tinyint(4) DEFAULT '0' COMMENT '退货状态0未确定   1正在退款 2 已完成 3已经取消 4拒绝退款',
  `option_ids` varchar(50) DEFAULT NULL COMMENT '规格id',
  `shop_id` int(11) DEFAULT NULL,
  `is_comment` tinyint(4) DEFAULT '0' COMMENT '已评',
  `unit_price` decimal(10,0) DEFAULT NULL,
  `shipping_status` tinyint(4) DEFAULT NULL,
  `score` int(11) DEFAULT NULL COMMENT '积分数量',
  `apply_notice` varchar(512) DEFAULT NULL COMMENT '退款声明',
  `refund_desc` varchar(225) DEFAULT NULL COMMENT '理由',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8");
E_D("replace into `jzb_order_product` values('1','1','4',0xe5ada6e7949fe68fa1e7ac94e599a8,0xe9bb98e8aea4,NULL,'5.00','1','0','0','0','0','1','0','5','0','0',NULL,NULL);");
E_D("replace into `jzb_order_product` values('2','2','7',0xe59fbae8afbae6b5a620e7a78be6acbee794b7e5a5b3e7aba5e99e8be5a9b4e584bfe99e8be5ae9de5ae9de998b2e6bb91e5ada6e6ada5e99e8be69cbae883bde99e8be8bf90e58aa8e99e8b545847323331,0xe9bb98e8aea4,NULL,'200.00','1','0','0','0','0','1','0','200','0','10',NULL,NULL);");
E_D("replace into `jzb_order_product` values('3','3','3',0xe584bfe7aba5e6898be8a1a8,0xe9bb98e8aea4,NULL,'0.00','1','0','0','0',NULL,'0','0',NULL,'0','0',NULL,NULL);");
E_D("replace into `jzb_order_product` values('4','4','3',0xe584bfe7aba5e6898be8a1a8,0xe9bb98e8aea4,NULL,'0.00','1','0','0','0',NULL,'0','0',NULL,'0','0',NULL,NULL);");
E_D("replace into `jzb_order_product` values('5','5','60',0xe89299e5a89ce4b8bde88e8ee59d90e4bebf,0xe9bb98e8aea4,NULL,'799.00','1','0','0','0','0','24','0','799','0','20',NULL,NULL);");

require("../../inc/footer.php");
?>